package com.example.javatwo.pojo.xs.lyh;

import java.util.Date;

import com.fasterxml.jackson.annotation.JsonFormat;

public class salesordersdetail {
//	DROP TABLE SalesOrdersDetail;
//	CREATE TABLE SalesOrdersDetail(
//		serNo INT(10) not null AUTO_INCREMENT, /*销售订单详表行号- 栏号*/
//		billNo VARCHAR(20) null ,/*外键*/	/*主表编号*/
//		prodID VARCHAR(50) null,	/*物料编号*/
//		prdClassName VARCHAR(50) null,	/*物料名称*/
//		prodSize     VARCHAR(50) null,	/*规格型号*/
//		sUnit        VARCHAR(20) null,	/*单位名称*/
//		sQuan	     INT(10)     null,	/*数量*/
//		oldPrice     double null,	/*折扣前单价*/
//		discount     double null,	/*折数(%)*/
//		sPrice       double null,	/*单价*/
//		amount	     double null,	/*金额*/
//		taxRate	     double null,	/*税率(%)*/
//		taxAmt	     double null,	/*税额*/
//		vFTotal	     double null,	/*含税金额*/
//		preInDate    DATE 	  null,	/*预出库日*/
//		qtyRemain    double null,	/*未出数量*/
//		isGift	     VARCHAR(20)  null,	/*赠品*/
//		itemRemark   VARCHAR(50)  null,	/*分录备注*/
//		hasCombine   VARCHAR(20)  null,	/*物料组合*/
//		tranType     VARCHAR(50)  null,	/*来源单别*/
//		fromNo	     VARCHAR(50)  null,	/*来源单号*/
//		isManu	     VARCHAR(20)  null,	/*生产*/
//		arrangeNo    VARCHAR(50)  null,	/*排程单号*/
//		manuQty	     double null,	/*已生产数量*/
//		FOREIGN KEY(billNo) REFERENCES XSOrders(billNo),
//		PRIMARY KEY(serNo)
//	);
	
	public int serNo;
	public String billNo;
	public String prodID;/*物料编号*/
	public String prdClassName;/*物料名称*/
	public String prodSize;/*规格型号*/
	public String sUnit;/*单位名称*/
	public int sQuan;/*数量*/
	public double oldPrice;/*折扣前单价*/
	public double discount;/*折数(%)*/
	public double sPrice;/*单价*/
	public double amount;/*金额*/
	public double taxRate;/*税率(%)*/
	public double taxAmt;/*税额*/
	public double vFTotal;/*含税金额*/
	
	@JsonFormat(pattern="yyyy-MM-dd",timezone="GMT+8",locale="zh")
	public Date preInDate;/*预出库日*/
	public double qtyRemain;/*未出数量*/
	public String isGift;/*赠品*/
	public String itemRemark;/*分录备注*/
	public String hasCombine;/*物料组合*/
	public String tranType;/*来源单别*/
	public String fromNo;/*来源单号*/
	public String isManu;/*生产*/
	public String arrangeNo;/*排程单号*/
	public double manuQty;/*已生产数量*/
	public salesorders orders;
	
	public int getSerNo() {
		return serNo;
	}
	public void setSerNo(int serNo) {
		this.serNo = serNo;
	}
	public String getBillNo() {
		return billNo;
	}
	public void setBillNo(String billNo) {
		this.billNo = billNo;
	}
	public String getProdID() {
		return prodID;
	}
	public void setProdID(String prodID) {
		this.prodID = prodID;
	}
	public String getPrdClassName() {
		return prdClassName;
	}
	public void setPrdClassName(String prdClassName) {
		this.prdClassName = prdClassName;
	}
	public String getProdSize() {
		return prodSize;
	}
	public void setProdSize(String prodSize) {
		this.prodSize = prodSize;
	}
	public String getsUnit() {
		return sUnit;
	}
	public void setsUnit(String sUnit) {
		this.sUnit = sUnit;
	}
	public int getsQuan() {
		return sQuan;
	}
	public void setsQuan(int sQuan) {
		this.sQuan = sQuan;
	}
	public double getOldPrice() {
		return oldPrice;
	}
	public void setOldPrice(double oldPrice) {
		this.oldPrice = oldPrice;
	}
	public double getDiscount() {
		return discount;
	}
	public void setDiscount(double discount) {
		this.discount = discount;
	}
	public double getsPrice() {
		return sPrice;
	}
	public void setsPrice(double sPrice) {
		this.sPrice = sPrice;
	}
	public double getAmount() {
		return amount;
	}
	public void setAmount(double amount) {
		this.amount = amount;
	}
	public double getTaxRate() {
		return taxRate;
	}
	public void setTaxRate(double taxRate) {
		this.taxRate = taxRate;
	}
	public double getTaxAmt() {
		return taxAmt;
	}
	public void setTaxAmt(double taxAmt) {
		this.taxAmt = taxAmt;
	}
	public double getvFTotal() {
		return vFTotal;
	}
	public void setvFTotal(double vFTotal) {
		this.vFTotal = vFTotal;
	}
	public Date getPreInDate() {
		return preInDate;
	}
	public void setPreInDate(Date preInDate) {
		this.preInDate = preInDate;
	}
	public double getQtyRemain() {
		return qtyRemain;
	}
	public void setQtyRemain(double qtyRemain) {
		this.qtyRemain = qtyRemain;
	}
	public String getIsGift() {
		return isGift;
	}
	public void setIsGift(String isGift) {
		this.isGift = isGift;
	}
	public String getItemRemark() {
		return itemRemark;
	}
	public void setItemRemark(String itemRemark) {
		this.itemRemark = itemRemark;
	}
	public String getHasCombine() {
		return hasCombine;
	}
	public void setHasCombine(String hasCombine) {
		this.hasCombine = hasCombine;
	}
	public String getTranType() {
		return tranType;
	}
	public void setTranType(String tranType) {
		this.tranType = tranType;
	}
	public String getFromNo() {
		return fromNo;
	}
	public void setFromNo(String fromNo) {
		this.fromNo = fromNo;
	}
	public String getIsManu() {
		return isManu;
	}
	public void setIsManu(String isManu) {
		this.isManu = isManu;
	}
	public String getArrangeNo() {
		return arrangeNo;
	}
	public void setArrangeNo(String arrangeNo) {
		this.arrangeNo = arrangeNo;
	}
	public double getManuQty() {
		return manuQty;
	}
	public void setManuQty(double manuQty) {
		this.manuQty = manuQty;
	}
	public salesordersdetail(int serNo, String billNo, String prodID, String prdClassName, String prodSize,
			String sUnit, int sQuan, double oldPrice, double discount, double sPrice, double amount, double taxRate,
			double taxAmt, double vFTotal, Date preInDate, double qtyRemain, String isGift, String itemRemark,
			String hasCombine, String tranType, String fromNo, String isManu, String arrangeNo, double manuQty,
			salesorders orders) {
		super();
		this.serNo = serNo;
		this.billNo = billNo;
		this.prodID = prodID;
		this.prdClassName = prdClassName;
		this.prodSize = prodSize;
		this.sUnit = sUnit;
		this.sQuan = sQuan;
		this.oldPrice = oldPrice;
		this.discount = discount;
		this.sPrice = sPrice;
		this.amount = amount;
		this.taxRate = taxRate;
		this.taxAmt = taxAmt;
		this.vFTotal = vFTotal;
		this.preInDate = preInDate;
		this.qtyRemain = qtyRemain;
		this.isGift = isGift;
		this.itemRemark = itemRemark;
		this.hasCombine = hasCombine;
		this.tranType = tranType;
		this.fromNo = fromNo;
		this.isManu = isManu;
		this.arrangeNo = arrangeNo;
		this.manuQty = manuQty;
		this.orders = orders;
	}
	public salesordersdetail() {
		super();
	}
	public salesordersdetail(String billNo, String prodID, String prdClassName, String prodSize, String sUnit,
			int sQuan, double oldPrice, double discount, double sPrice, double amount, double taxRate, double taxAmt,
			double vFTotal, Date preInDate, double qtyRemain, String isGift, String itemRemark, String hasCombine,
			String tranType, String fromNo, String isManu, String arrangeNo, double manuQty) {
		super();
		this.billNo = billNo;
		this.prodID = prodID;
		this.prdClassName = prdClassName;
		this.prodSize = prodSize;
		this.sUnit = sUnit;
		this.sQuan = sQuan;
		this.oldPrice = oldPrice;
		this.discount = discount;
		this.sPrice = sPrice;
		this.amount = amount;
		this.taxRate = taxRate;
		this.taxAmt = taxAmt;
		this.vFTotal = vFTotal;
		this.preInDate = preInDate;
		this.qtyRemain = qtyRemain;
		this.isGift = isGift;
		this.itemRemark = itemRemark;
		this.hasCombine = hasCombine;
		this.tranType = tranType;
		this.fromNo = fromNo;
		this.isManu = isManu;
		this.arrangeNo = arrangeNo;
		this.manuQty = manuQty;
	}
	public salesordersdetail(String billNo, String prodID, String prdClassName, String prodSize, String sUnit,
			int sQuan, double oldPrice, double discount, double sPrice, double amount, double taxRate, double taxAmt,
			double vFTotal, Date preInDate, double qtyRemain, String isGift, String itemRemark, String hasCombine,
			String tranType, String fromNo, String isManu, String arrangeNo, double manuQty, salesorders orders) {
		super();
		this.billNo = billNo;
		this.prodID = prodID;
		this.prdClassName = prdClassName;
		this.prodSize = prodSize;
		this.sUnit = sUnit;
		this.sQuan = sQuan;
		this.oldPrice = oldPrice;
		this.discount = discount;
		this.sPrice = sPrice;
		this.amount = amount;
		this.taxRate = taxRate;
		this.taxAmt = taxAmt;
		this.vFTotal = vFTotal;
		this.preInDate = preInDate;
		this.qtyRemain = qtyRemain;
		this.isGift = isGift;
		this.itemRemark = itemRemark;
		this.hasCombine = hasCombine;
		this.tranType = tranType;
		this.fromNo = fromNo;
		this.isManu = isManu;
		this.arrangeNo = arrangeNo;
		this.manuQty = manuQty;
		this.orders = orders;
	}
	@Override
	public String toString() {
		return "salesordersdetail [serNo=" + serNo + ", billNo=" + billNo + ", prodID=" + prodID + ", prdClassName="
				+ prdClassName + ", prodSize=" + prodSize + ", sUnit=" + sUnit + ", sQuan=" + sQuan + ", oldPrice="
				+ oldPrice + ", discount=" + discount + ", sPrice=" + sPrice + ", amount=" + amount + ", taxRate="
				+ taxRate + ", taxAmt=" + taxAmt + ", vFTotal=" + vFTotal + ", preInDate=" + preInDate + ", qtyRemain="
				+ qtyRemain + ", isGift=" + isGift + ", itemRemark=" + itemRemark + ", hasCombine=" + hasCombine
				+ ", tranType=" + tranType + ", fromNo=" + fromNo + ", isManu=" + isManu + ", arrangeNo=" + arrangeNo
				+ ", manuQty=" + manuQty + ", orders=" + orders + "]";
	}
	
	
}
